Setting Rule Properties

Use the Rule Name edit box to set the rule name. This must be distinct from the name of any other rule for the same table. Multiple rules on the same table and same event type are applied in alphabetical name order.

Event Type
The event is one of SELECT, INSERT, UPDATE, or DELETE.

Do

also
This indicates that the commands should be executed in addition to the original command.

instead
This indicates that the commands should be executed instead of the original command.

Condition
Any SQL conditional expression (returning boolean). The condition expression may not refer to any tables except NEW and OLD, and may not contain aggregate functions.

Commands
The command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.

Within condition and command, the special table names NEW and OLD may be used to refer to values in the referenced table. NEW is valid in ON INSERT and ON UPDATE rules to refer to the new row being inserted or updated. OLD is valid in ON UPDATE and ON DELETE rules to refer to the existing row being updated or deleted

The Comment edit box defines the comment for the rule.